oracle LISTAGG 谐褉褍锌锌懈褉芯胁泻邪 薪械褋泻芯谢褜泻懈褏 褉械蟹褍谢褜褌邪褌芯胁 褋褌褉芯泻 胁 芯写薪褍 薪械 褉邪斜芯褌邪械褌. ORA |
您所在的位置：网站首页 › sql listagg › oracle LISTAGG 谐褉褍锌锌懈褉芯胁泻邪 薪械褋泻芯谢褜泻懈褏 褉械蟹褍谢褜褌邪褌芯胁 褋褌褉芯泻 胁 芯写薪褍 薪械 褉邪斜芯褌邪械褌. ORA |
|
oracle LISTAGG 谐褉褍锌锌懈褉芯胁泻邪 薪械褋泻芯谢褜泻懈褏 褉械蟹褍谢褜褌邪褌芯胁 褋褌褉芯泻 胁 芯写薪褍 薪械 褉邪斜芯褌邪械褌. ORA-009
校胁懈写械谢 褌褍褌 锌芯褋褌 写谢褟 懈褋锌芯谢褜蟹芯胁邪薪懈褟 LISTAGG 写谢褟 谐褉褍锌锌懈褉芯胁泻懈 薪械褋泻芯谢褜泻懈褏 褋褌褉芯泻 胁 芯写薪褍 褋褌褉芯泻褍 锌芯写 1 泻芯谢芯薪泻芯泄, 锌芯褋屑芯褌褉械谢 锌褉懈屑械褉 锌芯褋褌邪 懈 褋邪泄褌 oracle 薪芯 薪懈泻邪泻 薪械 屑芯谐褍 蟹邪褋褌邪胁懈褌褜 蟹邪锌褉芯褋 褉邪斜芯褌邪褌褜. 袙 sql developer 芯褕懈斜泻邪 ORA-00909: invalid number of arguments 袠屑械褞 褋谢械写褍褞褖懈泄 蟹邪锌褉芯褋 select d.id, d.name, d.date_sale, d.address, d.city, d.state, d.zipcode, d.description, d.explanation, d.received_date, listagg(dd.my_id, dd.customer_name, dd.category, dd.transaction_date, ';' ) within group (order by dd.transaction_date) from table1 d left join table2 dd on d.id = dd.my_id where d.id =1 and d.isActive =1袥褞斜邪褟 锌芯屑芯褖褜 褑械薪懈褌褋褟. sql oracle aggregate 袠褋褌芯褔薪懈泻 09 屑邪褉褌邪 2020 胁 12:211 芯褌胁械褌 Oracle multple rows to single row 携 褏芯褔褍 泻芯薪泻邪褌械薪懈褉芯胁邪褌褜 薪械褋泻芯谢褜泻芯 褋褌褉芯泻 泻 褋懈谐谢褜薪芯泄 褋褌褉芯泻械 胁 oracle. 袧懈卸械 褌芯 褔械谐芯 褟 锌褘褌邪褞褋褜 写芯斜懈褌褜褋褟 孝邪斜谢懈褑邪 case case_id Name 1 AAA 2 BBB 孝邪斜谢懈褑邪 Subject case_id Subject 1 ENG 1 MATH 1 SCI 2 ENG 2 HIS 孝邪斜谢懈褑邪 SUB_LOOKUP Abbr Subject ENG English MATH Mathematics SCI Science HIS History 袨卸懈写邪械屑褘泄... 袗谐褉械谐邪褑懈褟 String 斜械蟹 懈褋锌芯谢褜蟹芯胁邪薪懈褟 ListAgg -- SIMPLE ANSWER (Oracle)袝褋褌褜 谢懈 锌褉芯褋褌芯泄 褋锌芯褋芯斜 褋写械谢邪褌褜 邪谐褉械谐邪褑懈褞 褋褌褉芯泻懈 斜械蟹 懈褋锌芯谢褜蟹芯胁邪薪懈褟 ListAgg? 携 薪芯胁懈褔芯泻 胁 Oracle 懈 褟 锌褘褌邪谢褋褟 懈褋锌芯谢褜蟹芯胁邪褌褜 褎褍薪泻褑懈褞 ListAgg 懈 芯薪邪 薪械 褉邪斜芯褔邪褟. 携 写褍屑邪褞 褍 屑械薪褟 褍褋褌邪薪芯胁谢械薪邪 胁械褉褋懈褟 泻芯褌芯褉邪褟 薪械 褋芯胁屑械褋褌懈屑邪 褋 ListAgg. 携 锌芯 褋褍褌懈 锌褘褌邪褞褋褜 褋写械谢邪褌褜 褋谢械写褍褞褖械械: 袗泻褌褍邪谢褜薪褘泄 List: Encounter ID CPT Code... 1袣芯薪泻邪褌械薪懈褉褍泄褌械 蟹薪邪褔械薪懈褟 胁屑械褋褌械 懈 写芯斜邪胁褜褌械 谐褉褍锌锌褍 group by: select d.id, d.name, d.date_sale, d.address, listagg(dd.my_id || dd.customer_name || dd.category, dd.transaction_date, ';' ) within group (order by dd.transaction_date) from table1 d left join table2 dd on d.id = dd.my_id where d.id =1 and d.isActive = 1 group by d.id, d.name, d.date_sale, d.address; 09 屑邪褉褌邪 2020 胁 12:24袩芯褏芯卸懈械 胁芯锌褉芯褋褘: Oracle - ORA-01489: 褉械蟹褍谢褜褌邪褌 泻芯薪泻邪褌械薪邪褑懈懈 褋褌褉芯泻 褋谢懈褕泻芯屑 写谢懈薪薪褘泄 小芯蟹写邪薪邪 芯写薪邪 胁褜褞褏邪, 胁薪褍褌褉懈 泻芯褌芯褉芯泄 芯写薪芯 field(懈蟹 6) - 泻芯薪泻邪褌械薪邪褑懈褟 写胁褍褏 锌芯谢械泄 懈蟹 懈褋褏芯写薪芯泄 褌邪斜谢懈褑褘. 小芯蟹写邪谢 胁褌芯褉褍褞 胁褜褞褏褍, 泻芯褌芯褉邪褟 懈褋锌芯谢褜蟹褍械褌 listagg, 褔褌芯斜褘 锌芯褌械薪褑懈邪谢褜薪芯 芯斜褗械写懈薪懈褌褜 褉械蟹褍谢褜褌邪褌褘... oracle listagg - 褋谢懈褕泻芯屑 写谢懈薪薪褘泄 褉械蟹褍谢褜褌邪褌 泻芯薪泻邪褌械薪邪褑懈懈 褋褌褉芯泻校 屑械薪褟 械褋褌褜 锌褉芯斜谢械屑邪, 泻芯褌芯褉褍褞 褟 薪懈泻邪泻 薪械 屑芯谐褍 褉械褕懈褌褜. 校 屑械薪褟 械褋褌褜 胁芯褌 褌邪泻芯械 褍褌胁械褉卸写械薪懈械: SELECT account, listagg(field1 || ', ') WITHIN GROUP ( ORDER BY field1 ) AS field1 FROM TABLE1 GROUP BY... Oracle sql 褋 锌芯屑芯褖褜褞 锌芯写蟹邪锌褉芯褋邪 褋谐褉褍锌锌懈褉芯胁邪褌褜 薪械褋泻芯谢褜泻芯 褉械蟹褍谢褜褌邪褌 褋褌褉芯泻 胁 芯写薪褍携 懈褋锌芯谢褜蟹芯胁邪谢 LISTAGG 泻芯褌芯褉褘泄 泻芯屑褍 褌芯 蟹写械褋褜 锌芯屑芯谐 薪芯 锌芯褋谢械 薪械褋泻芯谢褜泻懈褏 select 锌芯谢械 褟 薪邪褔邪谢 锌芯谢褍褔邪褌褜 芯褕懈斜泻褍 ORA. 携 斜褘 褋泻芯褉械械 懈褋锌芯谢褜蟹芯胁邪谢 锌芯写蟹邪锌褉芯褋 Oracle 写谢褟 谐褉褍锌锌懈褉芯胁泻懈 薪械褋泻芯谢褜泻懈褏 褉械蟹褍谢褜褌邪褌芯胁 褋褌褉芯泻 胁... Oracle multple rows to single row携 褏芯褔褍 泻芯薪泻邪褌械薪懈褉芯胁邪褌褜 薪械褋泻芯谢褜泻芯 褋褌褉芯泻 泻 褋懈谐谢褜薪芯泄 褋褌褉芯泻械 胁 oracle. 袧懈卸械 褌芯 褔械谐芯 褟 锌褘褌邪褞褋褜 写芯斜懈褌褜褋褟 孝邪斜谢懈褑邪 case case_id Name 1 AAA 2 BBB 孝邪斜谢懈褑邪 Subject case_id Subject 1 ENG 1 MATH 1 SCI 2 ENG 2... 袗谐褉械谐邪褑懈褟 String 斜械蟹 懈褋锌芯谢褜蟹芯胁邪薪懈褟 ListAgg -- SIMPLE ANSWER (Oracle)袝褋褌褜 谢懈 锌褉芯褋褌芯泄 褋锌芯褋芯斜 褋写械谢邪褌褜 邪谐褉械谐邪褑懈褞 褋褌褉芯泻懈 斜械蟹 懈褋锌芯谢褜蟹芯胁邪薪懈褟 ListAgg? 携 薪芯胁懈褔芯泻 胁 Oracle 懈 褟 锌褘褌邪谢褋褟 懈褋锌芯谢褜蟹芯胁邪褌褜 褎褍薪泻褑懈褞 ListAgg 懈 芯薪邪 薪械 褉邪斜芯褔邪褟. 携 写褍屑邪褞 褍 屑械薪褟 褍褋褌邪薪芯胁谢械薪邪 胁械褉褋懈褟 泻芯褌芯褉邪褟 薪械... 袣芯薪泻邪褌械薪邪褑懈褟 蟹薪邪褔械薪懈泄 褋褌芯谢斜褑邪 懈蟹 薪械褋泻芯谢褜泻懈褏 褋褌褉芯泻 胁 Oracle 斜械蟹 写褍斜谢懈泻邪褌芯胁携 屑芯谐褍 泻芯薪泻邪褌械薪懈褉芯胁邪褌褜 蟹薪邪褔械薪懈褟 褋褌芯谢斜褑芯胁 懈蟹 薪械褋泻芯谢褜泻懈褏 褋褌褉芯泻 胁 Oracle 褋 锌芯屑芯褖褜褞 LISTAGG 袧芯 褟 褏芯褔褍 懈蟹斜械卸邪褌褜 写褍斜谢懈泻邪褌芯胁 袧邪 褌械泻褍褖懈泄 屑芯屑械薪褌 芯薪 胁芯蟹胁褉邪褖邪械褌 写褍斜谢懈泻邪褌褘 select LISTAGG( t.id,',') WITHIN GROUP... 校褉械蟹邪薪薪邪褟 褋褌褉芯泻邪 LISTAGG携 懈褋锌芯谢褜蟹褍褞 Oracle 11g r2 懈 屑薪械 薪褍卸薪芯 泻芯薪泻邪褌械薪懈褉芯胁邪褌褜 褋褌褉芯泻懈 (VARCHAR2, 300) 懈蟹 薪械褋泻芯谢褜泻懈褏 褋褌褉芯泻. 携 懈褋锌芯谢褜蟹褍褞 LISTAGG 泻芯褌芯褉褘泄 锌褉械泻褉邪褋薪芯 褉邪斜芯褌邪械褌 写芯 褌械褏 锌芯褉 锌芯泻邪 泻芯薪泻邪褌械薪懈褉芯胁邪薪薪邪褟 褋褌褉芯泻邪 薪械 写芯褋褌懈谐薪械褌... 袣芯薪泻邪褌械薪懈褉芯胁邪褌褜 写胁械 褋褌褉芯泻懈 胁 芯写薪芯屑 褋褌芯谢斜褑械 胁 芯写薪褍 褋褌褉芯泻褍 (Oracle); 懈褋锌芯谢褜蟹芯胁邪褌褜 LISTAGG?携 懈褋锌芯谢褜蟹褍褞 Oracle 胁 Hyperion Studio. 袩芯谢邪谐邪褞, 褔褌芯 褝褌芯 Oracle 11, 薪芯 薪械 褍胁械褉械薪, 泻邪泻 锌褉芯胁械褉懈褌褜... 协褌芯 胁褋褢 写芯胁芯谢褜薪芯 薪芯胁芯械 写谢褟 屑械薪褟, 懈 褟 芯褔械薪褜-芯褔械薪褜 薪邪褔懈薪邪褞褖懈泄, 锌褉芯褕褍 锌褉芯褖械薪懈褟. 袙 谢褞斜芯屑 褋谢褍褔邪械, 褟 褋... oracle sql listaggSELECT deptno, LISTAGG(ename, ',') WITHIN GROUP (ORDER BY ename) AS employees FROM emp GROUP BY deptno; Error:- ORA-00923: FROM keyword not found where expected 00923. 00000 - FROM keyword not found... 肖芯褉屑邪褌懈褉芯胁邪薪懈械 褋褌褉芯泻懈 褋 锌芯屑芯褖褜褞 LISTAGG 胁 Oracle. 袠褋褔械蟹薪芯胁械薪懈械 芯写懈薪邪褉薪芯泄 泻邪胁褘褔泻懈 ` ' `袣邪泻 屑芯卸薪芯 芯褌褎芯褉屑邪褌懈褉芯胁邪褌褜 胁褘胁芯写 listagg 胁 Oracle, 褔褌芯斜褘 锌褉芯懈蟹胁械褋褌懈 output(泻邪卸写芯械 锌芯谢械 胁 芯写懈薪邪褉薪芯泄 褑懈褌邪褌械) 泻邪泻 'student1', 'student2', 'student3' . 携 褍卸械 锌械褉械斜褉邪谢 写芯泻褍屑械薪褌邪褑懈褞 懈 写褉褍谐懈械 胁芯锌褉芯褋 锌芯... |
| CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |